CREATE TABLE [dbo].[WorkItem]
(
[WorkItemKey] [uniqueidentifier] NOT NULL,
[WorkflowDefinitionKey] [uniqueidentifier] NOT NULL,
[ProcessEngineKey] [uniqueidentifier] NOT NULL,
[Sequence] [int] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[WorkItem] ADD CONSTRAINT [PK_WorkItem] PRIMARY KEY CLUSTERED ([WorkItemKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_WorkItem_ProcessEngineKey] ON [dbo].[WorkItem] ([ProcessEngineKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_WorkItem_WorkflowDefinitionKey] ON [dbo].[WorkItem] ([WorkflowDefinitionKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[WorkItem] ADD CONSTRAINT [FK_WorkItem_DocumentMain_ProcessEngine] FOREIGN KEY ([ProcessEngineKey]) REFERENCES [dbo].[DocumentMain] ([DocumentKey])
GO
ALTER TABLE [dbo].[WorkItem] ADD CONSTRAINT [FK_WorkItem_DocumentMain_WorkflowDefinition] FOREIGN KEY ([WorkflowDefinitionKey]) REFERENCES [dbo].[DocumentMain] ([DocumentKey])
GO